USE [Training]
GO

IF NOT EXISTS (SELECT * from dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.training_api_DepartmentTreeDelete'))
	EXEC('CREATE PROC dbo.training_api_DepartmentTreeDelete AS')
GO

ALTER PROC dbo.training_api_DepartmentTreeDelete
	@DepartmentTreeID	int 
AS
	DELETE FROM DepartmentTree
	WHERE DepartmentTreeID = @DepartmentTreeID
